package com.wlhse.dao;

import com.wlhse.entity.ProblemSourcePojo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ProblemSourceDao {
    //查全部-分页
    List<ProblemSourcePojo> queryProblemSource(ProblemSourcePojo pojo);

    //查 By Id
    ProblemSourcePojo queryProblemSourceyId(@Param("id") Integer id);

    //改
    int updateProblemSource(ProblemSourcePojo pojo);

    //删
    int deleteProblemSource(@Param("id") Integer id);

    //增
    int insertProblemSource(ProblemSourcePojo pojo);

    //模糊查
    List<ProblemSourcePojo> queryProblemSourceByVagueCondition(@Param("keyword") String keyword);

    //查总数
    int queryTotal();

    List<ProblemSourcePojo> queryProblemSourceBySourceName(@Param("problemSourceName") String problemSourceName);

    int queryTotal2(@Param("problemSourceName") String problemSourceName);

    String getMaxString();
}
